package com.qf.mapper;

import com.qf.entity.Student;
import com.qf.entity.StudentVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentMapper {
    Student findById(int id);

    List<Student> findAllStudent();

    List<Student> findStudentByAgeOrName(@Param("sname") String sname, @Param("age") int age);

    int addStudent(Student student);

    int updateStudent(Student student);

    int deleteStudent(int id);

    void deleteBatch(List<Integer> ids);

    List<StudentVO> findAllStudentAndClassroom();

    StudentVO findStudentAndAllSubjectByStuid(int sid);

    StudentVO findStudentMsgByStuid(int sid);

    List<Integer> findAllSubjectId(int sid);
}
